{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["1) Instructions","2) Commune","3) Associations","4) Cautionnements","5) Synthèse","6) Formulaire simple","7) Paramètres"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1) Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"2) Commune","index":1,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[31,1,31,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[33,1,33,2]]}
["Données communale"]
[]
[" BILAN - Résumé des comptes",null,2015,{"$f":"+C3+1","v":2016},2017,2018,2019,2020,2021]
["920 + 921 + 922 + 923","Dettes et engagements",null,{"$f":"C4+D37-D40","v":0},{"$f":"D4+E37-E40","v":0},{"$f":"E4+F37-F40","v":0},{"$f":"F4+G37-G40","v":0},{"$f":"G4+H37-H40","v":0},{"$f":"H4+I37-I40","v":0}]
[925,"Passifs transitoires"]
["910 + 911 + 912 + 913","Actifs circulants et patrimoine financier",null,{"$f":"C6+D29+D33-D35-D38-D40","v":0},{"$f":"D6+E29+E33-E35-E38-E40","v":0},{"$f":"E6+F29+F33-F35-F38-F40","v":0},{"$f":"F6+G29+G33-G35-G38-G40","v":0},{"$f":"G6+H29+H33-H35-H38-H40","v":0},{"$f":"H6+I29+I33-I35-I38-I40","v":0}]
[null,"Dette brute",{"$f":"C4","v":0},{"$f":"D4","v":0},{"$f":"E4","v":0},0,0,0,0]
[null,"Dette nette",{"$f":"SUM(C4:C5)-C6","v":0},0,0,0,0,0,0]
[]
["FONCTIONNEMENT - Résumé des comptes",null,{"$f":"C3","v":2015},2016,2017,2018,2019,2020,2021]
[425,"Revenus prêts du patrimoine admin."]
[427,"Revenus immeubles du patrimoine admin."]
[431,"Emoluments"]
[40,"Impôts"]
[41,"Pattentes, concessions"]
[42,"Revenus du patrimoine"]
[43,"Taxes, émoluments, produits"]
[44,"Parts aux recettes cantonales"]
[45,"Participation, remb. coll. pub."]
[46,"Autres participations, sub."]
[30,"Autorité et personnel"]
[31,"Biens, services, marchandises"]
[32,"Intérêts passifs"]
[330,"Amort. partrimoine financier"]
[35,"Remboursements, participations"]
[36,"Aides et subventions"]
[null,"Revenus courants",{"$f":"SUM(C14:C20)","v":0},{"$f":"SUM(D14:D20)","v":0},0,0,0,0,0]
[null,"Revenus fiscaux et autres",{"$f":"SUM(C11:C15)","v":0},{"$f":"SUM(D11:D15)","v":0},0,0,0,0,0]
[null,"Marge d'autofinancement",{"$f":"SUM(C14:C20)-SUM(C21:C26)","v":0},{"$f":"SUM(D14:D20)-SUM(D21:D26)","v":0},0,0,0,0,0]
[]
["INVESTISSEMENTS COMMUNAUX PROPRES",null,null,{"$f":"D10","v":2016},2017,2018,2019,2020,2021]
[5,"Dépenses d'investissement du patrimoine administratif"]
[null,"Dépenses d'investissement du patrimoine financier"]
["61 +62 +66","Recettes d'investissement du patrimoine administratif"]
[null,"Recettes d'investissement du patrimoine financier"]
[null,"Investissements nets",null,{"$f":"D32+D33-D34-D35","v":0},{"$f":"E32+E33-E34-E35","v":0},{"$f":"F32+F33-F34-F35","v":0},{"$f":"G32+G33-G34-G35","v":0},{"$f":"H32+H33-H34-H35","v":0},{"$f":"I32+I33-I34-I35","v":0}]
["A financer par ","Dette/Emprunt"]
[null,"Trésorerie"]
[null,null,null,{"$f":"D36-D37-D38","v":0},0,0,0,0,0]
[null,"Remboursements d'emprunts par des liquidités"]

{"sheet":"3) Associations","index":2,"n_rows":56,"n_cols":33,"rows_kept":56,"cut":false,"hidden":false,"merged":[[28,1,29,1],[28,0,29,0],[43,0,44,0],[43,1,44,1],[43,2,43,13],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[44,12,44,13],[29,2,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[28,2,28,13],[3,15,3,17],[3,30,3,32],[2,18,2,20],[2,21,2,23],[2,24,2,26],[2,27,2,29],[2,30,2,32],[3,18,3,20],[3,21,3,23],[3,24,3,26],[18,30,18,32],[2,12,2,14],[2,15,2,17],[3,27,3,29],[2,0,4,1],[2,2,4,2],[17,24,17,26],[2,3,2,5],[2,6,2,8],[2,9,2,11],[17,6,17,8],[17,9,17,11],[17,12,17,14],[17,15,17,17],[17,18,17,20],[17,21,17,23],[3,3,3,5],[3,6,3,8],[3,9,3,11],[3,12,3,14],[17,0,19,1],[17,2,19,2],[17,3,17,5],[17,27,17,29],[17,30,17,32],[18,3,18,5],[18,6,18,8],[18,9,18,11],[18,12,18,14],[18,15,18,17],[18,18,18,20],[18,24,18,26],[18,21,18,23],[18,27,18,29]]}
["Données des associations de communes consolidées"]
[]
["BILAN - Résumé des comptes",null,"Dettes au 31.12.2015","Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité"]
[null,null,null,"#NOM",null,null,"#NOM",null,null,"#NOM",null,null,"#NOM",null,null,"#NOM",null,null,"#NOM",null,null,"#NOM",null,null,"#NOM",null,null,"#NOM",null,null,"#NOM"]
[null,null,null,"Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF"]
[920,"Engagements courants",{"$f":"F6+I6+L6+O6+R6+U6+X6+AA6+AD6+AG6","v":0},null,null,{"$f":"D6*E6","v":0},null,null,{"$f":"G6*H6","v":0},null,null,{"$f":"J6*K6","v":0},null,null,{"$f":"M6*N6","v":0},null,null,{"$f":"P6*Q6","v":0},null,null,{"$f":"S6*T6","v":0},null,null,{"$f":"V6*W6","v":0},null,null,{"$f":"Y6*Z6","v":0},null,null,{"$f":"AB6*AC6","v":0},null,null,{"$f":"AE6*AF6","v":0}]
[921,"Dettes à court terme",{"$f":"F7+I7+L7+O7+R7+U7+X7+AA7+AD7+AG7","v":0},null,{"$f":"E6","v":0},{"$f":"D7*E7","v":0},null,{"$f":"H6","v":0},{"$f":"G7*H7","v":0},null,{"$f":"K6","v":0},{"$f":"J7*K7","v":0},null,{"$f":"N6","v":0},{"$f":"M7*N7","v":0},null,{"$f":"Q6","v":0},{"$f":"P7*Q7","v":0},null,{"$f":"T6","v":0},{"$f":"S7*T7","v":0},null,{"$f":"W6","v":0},{"$f":"V7*W7","v":0},null,{"$f":"Z6","v":0},{"$f":"Y7*Z7","v":0},null,{"$f":"AC6","v":0},{"$f":"AB7*AC7","v":0},null,{"$f":"AF6","v":0},{"$f":"AE7*AF7","v":0}]
[922,"Emprunt à moyen et long terme",0,null,{"$f":"E7","v":0},{"$f":"D8*E8","v":0},null,{"$f":"H7","v":0},{"$f":"G8*H8","v":0},null,{"$f":"K7","v":0},{"$f":"J8*K8","v":0},null,{"$f":"N7","v":0},{"$f":"M8*N8","v":0},null,{"$f":"Q7","v":0},{"$f":"P8*Q8","v":0},null,{"$f":"T7","v":0},{"$f":"S8*T8","v":0},null,{"$f":"W7","v":0},{"$f":"V8*W8","v":0},null,{"$f":"Z7","v":0},{"$f":"Y8*Z8","v":0},null,{"$f":"AC7","v":0},{"$f":"AB8*AC8","v":0},null,{"$f":"AF7","v":0},{"$f":"AE8*AF8","v":0}]
[923,"Engagements propres établis. et fonds",0,null,0,{"$f":"D9*E9","v":0},null,0,{"$f":"G9*H9","v":0},null,0,{"$f":"J9*K9","v":0},null,0,{"$f":"M9*N9","v":0},null,0,{"$f":"P9*Q9","v":0},null,0,{"$f":"S9*T9","v":0},null,0,{"$f":"V9*W9","v":0},null,0,{"$f":"Y9*Z9","v":0},null,0,{"$f":"AB9*AC9","v":0},null,0,{"$f":"AE9*AF9","v":0}]
[925,"Passifs transitoires",0,null,0,{"$f":"D10*E10","v":0},null,0,{"$f":"G10*H10","v":0},null,0,{"$f":"J10*K10","v":0},null,0,{"$f":"M10*N10","v":0},null,0,{"$f":"P10*Q10","v":0},null,0,{"$f":"S10*T10","v":0},null,0,{"$f":"V10*W10","v":0},null,0,{"$f":"Y10*Z10","v":0},null,0,{"$f":"AB10*AC10","v":0},null,0,{"$f":"AE10*AF10","v":0}]
[910,"Disponibilités ./.",0,null,{"$f":"E7","v":0},{"$f":"D11*E11","v":0},null,{"$f":"H7","v":0},{"$f":"G11*H11","v":0},null,{"$f":"K7","v":0},{"$f":"J11*K11","v":0},null,{"$f":"N7","v":0},{"$f":"M11*N11","v":0},null,{"$f":"Q7","v":0},{"$f":"P11*Q11","v":0},null,{"$f":"T7","v":0},{"$f":"S11*T11","v":0},null,{"$f":"W7","v":0},{"$f":"V11*W11","v":0},null,{"$f":"Z7","v":0},{"$f":"Y11*Z11","v":0},null,{"$f":"AC7","v":0},{"$f":"AB11*AC11","v":0},null,{"$f":"AF7","v":0},{"$f":"AE11*AF11","v":0}]
[911,"Débiteurs et comptes courants ./.",0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[912,"Placements du patrimoine financier ./.",0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[913,"Actifs transitoires ./.",0,null,{"$f":"E9","v":0},0,null,{"$f":"H9","v":0},0,null,{"$f":"K9","v":0},0,null,{"$f":"N9","v":0},0,null,{"$f":"Q9","v":0},0,null,{"$f":"T9","v":0},0,null,{"$f":"W9","v":0},0,null,{"$f":"Z9","v":0},0,null,{"$f":"AC9","v":0},0,null,{"$f":"AF9","v":0},0]
[null,"Dette brute",{"$f":"SUM(C6:C9)","v":0}]
[null,"Dette nette",{"$f":"SUM(C6:C10)-SUM(C11:C14)","v":0}]
[]
["FONCTIONNEMENT -Résumé des comptes",null,"Revenus courants au 31.12.2015","Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité",null,null,"Association ou autre entité"]
[null,null,null,{"$f":"D4","v":"#NOM"},null,null,{"$f":"G4","v":"#NOM"},null,null,{"$f":"J4","v":"#NOM"},null,null,{"$f":"M4","v":"#NOM"},null,null,{"$f":"P4","v":"#NOM"},null,null,{"$f":"S4","v":"#NOM"},null,null,{"$f":"V4","v":"#NOM"},null,null,{"$f":"Y4","v":"#NOM"},null,null,{"$f":"AB4","v":"#NOM"},null,null,{"$f":"AE4","v":"#NOM"}]
[null,null,null,"Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF","Résumé compte","Quote-part %","Quote-part CHF"]
[41,"Patentes, concessions",{"$f":"F21+I21+L21+O21+R21+U21+X21+AA21+AD21+AG21","v":0},null,{"$f":"E6","v":0},{"$f":"D21*E21","v":0},null,{"$f":"H6","v":0},{"$f":"G21*H21","v":0},null,{"$f":"K6","v":0},{"$f":"J21*K21","v":0},null,{"$f":"N6","v":0},{"$f":"M21*N21","v":0},null,{"$f":"Q6","v":0},{"$f":"P21*Q21","v":0},null,{"$f":"T6","v":0},{"$f":"S21*T21","v":0},null,{"$f":"W6","v":0},{"$f":"V21*W21","v":0},null,{"$f":"Z6","v":0},{"$f":"Y21*Z21","v":0},null,{"$f":"AC6","v":0},{"$f":"AB21*AC21","v":0},null,{"$f":"AF6","v":0},{"$f":"AE21*AF21","v":0}]
[42,"Revenus du patrimoine",{"$f":"F22+I22+L22+O22+R22+U22+X22+AA22+AD22+AG22","v":0},null,{"$f":"E21","v":0},0,null,{"$f":"H21","v":0},0,null,{"$f":"K21","v":0},0,null,{"$f":"N21","v":0},0,null,{"$f":"Q21","v":0},0,null,{"$f":"T21","v":0},0,null,{"$f":"W21","v":0},0,null,{"$f":"Z21","v":0},0,null,{"$f":"AC21","v":0},0,null,{"$f":"AF21","v":0},0]
[43,"Taxes, émoluments, produits",0,null,{"$f":"E22","v":0},0,null,{"$f":"H22","v":0},0,null,{"$f":"K22","v":0},0,null,{"$f":"N22","v":0},0,null,{"$f":"Q22","v":0},0,null,{"$f":"T22","v":0},0,null,{"$f":"W22","v":0},0,null,{"$f":"Z22","v":0},0,null,{"$f":"AC22","v":0},0,null,{"$f":"AF22","v":0},0]
[44,"Parts aux recettes cantonales",0,null,{"$f":"E23","v":0},0,null,{"$f":"H23","v":0},0,null,{"$f":"K23","v":0},0,null,{"$f":"N23","v":0},0,null,{"$f":"Q23","v":0},0,null,{"$f":"T23","v":0},0,null,{"$f":"W23","v":0},0,null,{"$f":"Z23","v":0},0,null,{"$f":"AC23","v":0},0,null,{"$f":"AF23","v":0},0]
[451,"Participation, remb. coll. pub. Canton",0,null,{"$f":"E23","v":0},0,null,{"$f":"H23","v":0},0,null,{"$f":"K23","v":0},0,null,{"$f":"N23","v":0},0,null,{"$f":"Q23","v":0},0,null,{"$f":"T23","v":0},0,null,{"$f":"W23","v":0},0,null,{"$f":"Z23","v":0},0,null,{"$f":"AC23","v":0},0,null,{"$f":"AF23","v":0},0]
[46,"Autres participations, sub.",0,null,{"$f":"E23","v":0},0,null,{"$f":"H23","v":0},0,null,{"$f":"K23","v":0},0,null,{"$f":"N23","v":0},0,null,{"$f":"Q23","v":0},0,null,{"$f":"T23","v":0},0,null,{"$f":"W23","v":0},0,null,{"$f":"Z23","v":0},0,null,{"$f":"AC23","v":0},0,null,{"$f":"AF23","v":0},0]
[null,"Revenus courants",{"$f":"SUM(C21:C26)","v":0}]
[]
["VARIATION DES DETTES + -","Quote-part %","Montants des variations par rapport à l'année précédente"]
[null,null,{"$f":"'2) Commune'!D3","v":2016},null,{"$f":"+C30+1","v":2017},null,{"$f":"+E30+1","v":2018},null,{"$f":"+G30+1","v":2019},null,{"$f":"+I30+1","v":2020},null,{"$f":"+K30+1","v":2021}]
[{"$f":"D19","v":"#NOM"},{"$f":"$E$6","v":0},null,{"$f":"C31*$B31","v":0},null,{"$f":"E31*$B31","v":0},null,{"$f":"G31*$B31","v":0},null,{"$f":"I31*$B31","v":0},null,{"$f":"K31*$B31","v":0},null,{"$f":"M31*$B31","v":0}]
[{"$f":"G19","v":"#NOM"},{"$f":"$H$6","v":0},null,0,null,{"$f":"E32*$B32","v":0},null,{"$f":"G32*$B32","v":0},null,{"$f":"I32*$B32","v":0},null,{"$f":"K32*$B32","v":0},null,{"$f":"M32*$B32","v":0}]
[{"$f":"J19","v":"#NOM"},{"$f":"$K$6","v":0},null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"M19","v":"#NOM"},{"$f":"$N$6","v":0},null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"P19","v":"#NOM"},{"$f":"$Q$6","v":0},null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"S19","v":"#NOM"},{"$f":"$T$6","v":0},null,0,null,0,null,0,null,0,null,0,null,{"$f":"M36*$B36","v":0}]
[{"$f":"V19","v":"#NOM"},{"$f":"$W$6","v":0},null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"Y19","v":"#NOM"},{"$f":"$Z$6","v":0},null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"AB19","v":"#NOM"},{"$f":"$AC$6","v":0},null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"AE19","v":"#NOM"},{"$f":"$AF$6","v":0},null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Dette brute projetée",null,{"$f":"$C$15+SUM(D31:D40)","v":0},null,{"$f":"D41+SUM(F31:F40)","v":0},null,{"$f":"F41+SUM(H31:H40)","v":0},null,{"$f":"H41+SUM(J31:J40)","v":0},null,{"$f":"J41+SUM(L31:L40)","v":0},null,{"$f":"L41+SUM(N31:N40)","v":0}]
[null,"Dette nette projetée",null,{"$f":"$C$16+SUM(D31:D40)","v":0},null,{"$f":"D42+SUM(F31:F40)","v":0},null,{"$f":"F42+SUM(H31:H40)","v":0},null,{"$f":"H42+SUM(J31:J40)","v":0},null,{"$f":"J42+SUM(L31:L40)","v":0},null,{"$f":"L42+SUM(N31:N40)","v":0}]
[]
["VARIATION DES REVENUS + -","Quote-part %","Montants des variations par rapport à l'année précédente"]
[null,null,{"$f":"C30","v":2016},null,{"$f":"E30","v":2017},null,{"$f":"G30","v":2018},null,{"$f":"I30","v":2019},null,{"$f":"K30","v":2020},null,{"$f":"M30","v":2021}]
[{"$f":"A31","v":"#NOM"},{"$f":"$E$6","v":0},null,{"$f":"C46*$B46","v":0},null,{"$f":"E46*$B46","v":0},null,{"$f":"G46*$B46","v":0},null,{"$f":"I46*$B46","v":0},null,{"$f":"K46*$B46","v":0},null,{"$f":"M46*$B46","v":0}]
["#NOM",{"$f":"$H$6","v":0},null,{"$f":"C47*$B47","v":0},null,{"$f":"E47*$B47","v":0},null,{"$f":"G47*$B47","v":0},null,{"$f":"I47*$B47","v":0},null,{"$f":"K47*$B47","v":0},null,{"$f":"M47*$B47","v":0}]
["#NOM",{"$f":"$K$6","v":0},null,{"$f":"C48*$B48","v":0},null,{"$f":"E48*$B48","v":0},null,{"$f":"G48*$B48","v":0},null,{"$f":"I48*$B48","v":0},null,{"$f":"K48*$B48","v":0},null,{"$f":"M48*$B48","v":0}]
["#NOM",{"$f":"$N$6","v":0},null,{"$f":"C49*$B49","v":0},null,{"$f":"E49*$B49","v":0},null,{"$f":"G49*$B49","v":0},null,{"$f":"I49*$B49","v":0},null,{"$f":"K49*$B49","v":0},null,{"$f":"M49*$B49","v":0}]
["#NOM",{"$f":"$Q$6","v":0},null,{"$f":"C50*$B50","v":0},null,{"$f":"E50*$B50","v":0},null,{"$f":"G50*$B50","v":0},null,{"$f":"I50*$B50","v":0},null,{"$f":"K50*$B50","v":0},null,{"$f":"M50*$B50","v":0}]
["#NOM",{"$f":"$T$6","v":0},null,{"$f":"C51*$B51","v":0},null,0,null,{"$f":"G51*$B51","v":0},null,{"$f":"I51*$B51","v":0},null,{"$f":"K51*$B51","v":0},null,{"$f":"M51*$B51","v":0}]
["#NOM",{"$f":"$W$6","v":0},null,0,null,0,null,{"$f":"G52*$B52","v":0},null,{"$f":"I52*$B52","v":0},null,{"$f":"K52*$B52","v":0},null,{"$f":"M52*$B52","v":0}]
["#NOM",{"$f":"$Z$6","v":0},null,0,null,0,null,{"$f":"G53*$B53","v":0},null,{"$f":"I53*$B53","v":0},null,{"$f":"K53*$B53","v":0},null,{"$f":"M53*$B53","v":0}]
["#NOM",{"$f":"$AC$6","v":0},null,0,null,0,null,{"$f":"G54*$B54","v":0},null,{"$f":"I54*$B54","v":0},null,{"$f":"K54*$B54","v":0},null,{"$f":"M54*$B54","v":0}]
["#NOM",{"$f":"$AF$6","v":0},null,0,null,0,null,{"$f":"G55*$B55","v":0},null,{"$f":"I55*$B55","v":0},null,{"$f":"K55*$B55","v":0},null,{"$f":"M55*$B55","v":0}]
[null,"Revenus courants projetés",null,{"$f":"$C$27+SUM(D46:D55)","v":0},null,{"$f":"D56+SUM(F46:F55)","v":0},null,{"$f":"F56+SUM(H46:H55)","v":0},null,{"$f":"H56+SUM(J46:J55)","v":0},null,{"$f":"J56+SUM(L46:L55)","v":0},null,{"$f":"L56+SUM(N46:N55)","v":0}]

{"sheet":"4) Cautionnements","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,5,2,7],[2,0,3,1],[2,2,2,4]]}
["Données des cautionnements pour les entités non consolidées"]
[]
["Cautionnements et garanties",null,{"$f":"'2) Commune'!C3","v":2015},null,null,{"$f":"CONCATENATE(\"Situation --> \",C3+6)","v":"Situation --> 2021"}]
[null,null,"Caution en CHF","Probabilité de survenance","Montant pris en compte","Caution en CHF","Probabilité de survenance","Montant pris en compte"]
["Cautionnement 1","#NOM",null,null,{"$f":"C5*D5","v":0},null,null,{"$f":"F5*G5","v":0}]
["Cautionnement 2","#NOM",null,null,{"$f":"C6*D6","v":0},null,null,{"$f":"F6*G6","v":0}]
["Cautionnement 3","#NOM",null,null,0,null,null,0]
["Cautionnement 4","#NOM",null,null,0,null,null,0]
["Cautionnement 5","#NOM",null,null,0,null,null,0]
["Cautionnement 6","#NOM",null,null,0,null,null,0]
["Cautionnement 7","#NOM",null,null,0,null,null,0]
["Cautionnement 8","#NOM",null,null,0,null,null,0]
["Cautionnement 9","#NOM",null,null,0,null,null,0]
["Cautionnement 10","#NOM",null,null,{"$f":"C14*D14","v":0},null,null,{"$f":"F14*G14","v":0}]
[null,"Cautionnements",{"$f":"SUM(C5:C14)","v":0},null,{"$f":"SUM(E5:E14)","v":0},{"$f":"SUM(F5:F14)","v":0},null,{"$f":"SUM(H5:H14)","v":0}]

{"sheet":"5) Synthèse","index":4,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,6],[37,0,37,4],[38,0,38,4],[39,0,39,4],[43,0,49,6],[42,0,42,6],[1,0,1,6]]}
["P l a f o n d   d ’ e n d e t t e m e n t"]
["Législature 2016 - 2021"]
[]
["Commune"]
["N° OFS",{"$f":"VLOOKUP(B4,'7) Paramètres'!$A:$C,2,FALSE)","v":{"$error":"#N/A"}}]
["District",{"$f":"VLOOKUP(B4,'7) Paramètres'!$A:$C,3,FALSE)","v":{"$error":"#N/A"}}]
[]
["Situation au 31.12.2015"]
[null,"Sans ass. autofin."]
["Quotité de dette brute",{"$f":"B11/B12","v":{"$error":"#DIV/0!"}}]
["Dette brute",{"$f":"'2) Commune'!C7+'3) Associations'!C15+'4) Cautionnements'!E15","v":0}]
["Revenus courants",{"$f":"'2) Commune'!C27+'3) Associations'!C27","v":0}]
["Quotité de dette nette",{"$f":"B14/B15","v":{"$error":"#DIV/0!"}}]
["Dette nette",{"$f":"'2) Commune'!C8+'3) Associations'!C16+'4) Cautionnements'!E15","v":0}]
["Revenus fiscaux et autres",{"$f":"'2) Commune'!C28+'3) Associations'!C27","v":0}]
[]
["Projections 2016 à 2021"]
["Sans ass. autofin.",{"$f":"'2) Commune'!D3","v":2016},{"$f":"'2) Commune'!E3","v":2017},{"$f":"'2) Commune'!F3","v":2018},{"$f":"'2) Commune'!G3","v":2019},{"$f":"'2) Commune'!H3","v":2020},{"$f":"'2) Commune'!I3","v":2021}]
["Quotité de dette brute",{"$f":"B23/B26","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Dette communale",{"$f":"'2) Commune'!D7","v":0},{"$f":"'2) Commune'!E7","v":0},{"$f":"'2) Commune'!F7","v":0},{"$f":"'2) Commune'!G7","v":0},{"$f":"'2) Commune'!H7","v":0},{"$f":"'2) Commune'!I7","v":0}]
["Dette associations",{"$f":"'3) Associations'!D41","v":0},{"$f":"'3) Associations'!F41","v":0},{"$f":"'3) Associations'!H41","v":0},{"$f":"'3) Associations'!J41","v":0},{"$f":"'3) Associations'!L41","v":0},{"$f":"'3) Associations'!N41","v":0}]
["Cautionnements",{"$f":"'4) Cautionnements'!$H$15","v":0},{"$f":"'4) Cautionnements'!$H$15","v":0},{"$f":"'4) Cautionnements'!$H$15","v":0},{"$f":"'4) Cautionnements'!$H$15","v":0},{"$f":"'4) Cautionnements'!$H$15","v":0},{"$f":"'4) Cautionnements'!$H$15","v":0}]
["Total",{"$f":"SUM(B20:B22)","v":0},{"$f":"SUM(C20:C22)","v":0},0,0,0,0]
["Revenus communaux",{"$f":"'2) Commune'!D27","v":0},{"$f":"'2) Commune'!E27","v":0},{"$f":"'2) Commune'!F27","v":0},{"$f":"'2) Commune'!G27","v":0},{"$f":"'2) Commune'!H27","v":0},{"$f":"'2) Commune'!I27","v":0}]
["Revenus associations",{"$f":"'3) Associations'!D56","v":0},{"$f":"'3) Associations'!F56","v":0},{"$f":"'3) Associations'!H56","v":0},{"$f":"'3) Associations'!J56","v":0},{"$f":"'3) Associations'!L56","v":0},{"$f":"'3) Associations'!N56","v":0}]
["Total",{"$f":"SUM(B24:B25)","v":0},{"$f":"SUM(C24:C25)","v":0},0,0,0,0]
[]
["Quotité de dette nette",{"$f":"B32/B35","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Dette communale",{"$f":"'2) Commune'!D8","v":0},{"$f":"'2) Commune'!E8","v":0},{"$f":"'2) Commune'!F8","v":0},{"$f":"'2) Commune'!G8","v":0},{"$f":"'2) Commune'!H8","v":0},{"$f":"'2) Commune'!I8","v":0}]
["Dette associations",{"$f":"'3) Associations'!D42","v":0},{"$f":"'3) Associations'!F42","v":0},{"$f":"'3) Associations'!H42","v":0},{"$f":"'3) Associations'!J42","v":0},{"$f":"'3) Associations'!L42","v":0},{"$f":"'3) Associations'!N42","v":0}]
["Cautionnements",{"$f":"'4) Cautionnements'!$H$15","v":0},{"$f":"'4) Cautionnements'!$H$15","v":0},{"$f":"'4) Cautionnements'!$H$15","v":0},{"$f":"'4) Cautionnements'!$H$15","v":0},{"$f":"'4) Cautionnements'!$H$15","v":0},{"$f":"'4) Cautionnements'!$H$15","v":0}]
["Total",{"$f":"SUM(B29:B31)","v":0},{"$f":"SUM(C29:C31)","v":0},0,0,0,0]
["Revenus communaux",{"$f":"'2) Commune'!D28","v":0},{"$f":"'2) Commune'!E28","v":0},{"$f":"'2) Commune'!F28","v":0},{"$f":"'2) Commune'!G28","v":0},{"$f":"'2) Commune'!H28","v":0},{"$f":"'2) Commune'!I28","v":0}]
["Revenus associations",{"$f":"'3) Associations'!D56","v":0},{"$f":"'3) Associations'!F56","v":0},{"$f":"'3) Associations'!H56","v":0},{"$f":"'3) Associations'!J56","v":0},{"$f":"'3) Associations'!L56","v":0},{"$f":"'3) Associations'!N56","v":0}]
["Total",{"$f":"SUM(B33:B34)","v":0},{"$f":"SUM(C33:C34)","v":0},0,0,0,0]
[]
["Choix fixé par le Conseil communal/général pour la législtature"]
[null,null,null,null,null,"Quotité brute","Quotité nette"]
["Quotité de dette maximale en % pour la période 2016 - 2021"]
["Endettement sans associations autofinancées max. en CHF",null,null,null,null,{"$f":"AVERAGE(B26:G26)*F39/100","v":0},{"$f":"AVERAGE(B35:G35)*G39/100","v":0}]
[]
[]
["Commentaires"]
[]
[]
[]
[]
[]
[]
[]
[]
["Certifié conforme au préavis adopté par le Conseil communal/général dans sa séance du"]
[]
[]
[]
[null,"Au nom de la Municipalité"]
[]
["La Syndique/Le Syndic",null,null,"La Secrétaire/Le Secrétaire Municipal(e) "]
[]
[]
[]
["Signatures"]
[]
[]
["Prénoms/noms"]
[{"$f":"CONCATENATE(B4,\", le\")","v":", le"}]
[{"$f":"TODAY()","v":"2016-12-20"}]

{"sheet":"6) Formulaire simple","index":5,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[17,0,23,6],[0,0,0,6],[1,0,1,6],[11,0,11,4],[12,0,12,4],[13,0,13,4],[16,0,16,6]]}
["P l a f o n d   d ’ e n d e t t e m e n t"]
["Législature 2016 - 2021"]
[]
["Commune"]
["N° OFS",{"$f":"VLOOKUP(B4,'7) Paramètres'!$A:$C,2,FALSE)","v":{"$error":"#N/A"}}]
["District",{"$f":"VLOOKUP(B4,'7) Paramètres'!$A:$C,3,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
["Choix fixé par le Conseil communal/général pour la législtature"]
[null,null,null,null,null,"Quotité brute","Quotité nette"]
["Quotité de dette maximale en % pour la période 2016 - 2021"]
["Endettement sans associations autofinancées max. en CHF"]
[]
[]
["Commentaires"]
[]
[]
[]
[]
[]
[]
[]
[]
["Certifié conforme au préavis adopté par le Conseil communal/général dans sa séance du"]
[]
[]
[]
[null,"Au nom de la Municipalité"]
[]
["La Syndique/Le Syndic",null,null,"La Secrétaire/Le Secrétaire Municipal(e) "]
[]
[]
[]
["Signatures"]
[]
[]
["Prénoms/noms"]
[{"$f":"CONCATENATE(B4,\", le\")","v":", le"}]
[{"$f":"TODAY()","v":"2016-12-20"}]

{"sheet":"7) Paramètres","index":6,"n_rows":400,"n_cols":5,"rows_kept":400,"cut":false,"hidden":false,"merged":[]}
["Commune","N° OFS","District",1,0]
["Aigle",5401,"Aigle",2,0.1]
["Bex",5402,"Aigle",3,0.2]
["Chessel",5403,"Aigle",4,0.3]
["Corbeyrier",5404,"Aigle",5,0.4]
["Gryon",5405,"Aigle",6,0.5]
["Lavey-Morcles",5406,"Aigle",7,0.6]
["Leysin",5407,"Aigle",8,0.7]
["Noville",5408,"Aigle",9,0.8]
["Ollon",5409,"Aigle",10,0.9]
["Ormont-Dessous",5410,"Aigle",11,1]
["Ormont-Dessus",5411,"Aigle",12]
["Rennaz",5412,"Aigle",13]
["Roche",5413,"Aigle",14]
["Villeneuve",5414,"Aigle",15]
["Yvorne",5415,"Aigle",16]
["Avenches",5451,"Broye-Vully",17]
["Brenles",5662,"Broye-Vully",18]
["Bussy-sur-Moudon",5663,"Broye-Vully",19]
["Carrouge",5782,"Broye-Vully",20]
["Champtauroz",5812,"Broye-Vully",21]
["Chavannes-sur-Moudon",5665,"Broye-Vully",22]
["Chesalles-sur-Moudon",5666,"Broye-Vully",23]
["Chevroux",5813,"Broye-Vully",24]
["Corcelles-le-Jorat",5785,"Broye-Vully",25]
["Corcelles-près-Payerne",5816,"Broye-Vully",26]
["Cremin",5668,"Broye-Vully",27]
["Cudrefin",5456,"Broye-Vully",28]
["Curtilles",5669,"Broye-Vully",29]
["Dompierre",5671,"Broye-Vully",30]
["Faoug",5458,"Broye-Vully",31]
["Forel-sur-Lucens",5672,"Broye-Vully",32]
["Grandcour",5817,"Broye-Vully",33]
["Henniez",5819,"Broye-Vully",34]
["Hermenches",5673,"Broye-Vully",35]
["Lovatens",5674,"Broye-Vully",36]
["Lucens",5675,"Broye-Vully",37]
["Missy",5821,"Broye-Vully",38]
["Moudon",5678,"Broye-Vully",39]
["Payerne",5822,"Broye-Vully",40]
["Prévonloup",5683,"Broye-Vully",41]
["Ropraz",5798,"Broye-Vully",42]
["Rossenges",5684,"Broye-Vully",43]
["Sarzens",5686,"Broye-Vully",44]
["Syens",5688,"Broye-Vully",45]
["Trey",5827,"Broye-Vully",46]
["Treytorrens (Payerne)",5828,"Broye-Vully",47]
["Valbroye",5831,"Broye-Vully",48]
["Villars-le-Comte",5690,"Broye-Vully",49]
["Villarzel",5830,"Broye-Vully",50]
["Vucherens",5692,"Broye-Vully",51]
["Vulliens",5803,"Broye-Vully",52]
["Vully-les-Lacs",5464,"Broye-Vully",53]
["Assens",5511,"Gros-de-Vaud",54]
["Bercher",5512,"Gros-de-Vaud",55]
["Bettens",5471,"Gros-de-Vaud",56]
["Bioley-Orjulaz",5513,"Gros-de-Vaud",57]
["Bottens",5514,"Gros-de-Vaud",58]
["Boulens",5661,"Gros-de-Vaud",59]
["Bournens",5472,"Gros-de-Vaud",60]
["Boussens",5473,"Gros-de-Vaud",61]
["Bretigny-sur-Morrens",5515,"Gros-de-Vaud",62]
["Cugy",5516,"Gros-de-Vaud",63]
["Daillens",5480,"Gros-de-Vaud",64]
["Echallens",5518,"Gros-de-Vaud",65]
["Essertines-sur-Yverdon",5520,"Gros-de-Vaud",66]
["Etagnières",5521,"Gros-de-Vaud",67]
["Fey",5522,"Gros-de-Vaud",68]
["Froideville",5523,"Gros-de-Vaud",69]
["Goumoëns",5541,"Gros-de-Vaud",70]
["Jorat-Menthue",5804,"Gros-de-Vaud",71]
["Lussery-Villars",5487,"Gros-de-Vaud",72]
["Mex",5489,"Gros-de-Vaud",73]
["Montanaire",5693,"Gros-de-Vaud",74]
["Montilliez",5540,"Gros-de-Vaud",75]
["Morrens",5527,"Gros-de-Vaud",76]
["Ogens",5680,"Gros-de-Vaud",77]
["Oppens",5923,"Gros-de-Vaud",78]
["Oulens-sous-Echallens",5529,"Gros-de-Vaud",79]
["Pailly",5530,"Gros-de-Vaud",80]
["Penthalaz",5495,"Gros-de-Vaud",81]
["Penthaz",5496,"Gros-de-Vaud",82]
["Penthéréaz",5531,"Gros-de-Vaud",83]
["Poliez-Pittet",5533,"Gros-de-Vaud",84]
["Rueyres",5534,"Gros-de-Vaud",85]
["Saint-Barthélemy",5535,"Gros-de-Vaud",86]
["Sullens",5501,"Gros-de-Vaud",87]
["Villars-le-Terroir",5537,"Gros-de-Vaud",88]
["Vuarrens",5539,"Gros-de-Vaud",89]
["Vufflens-la-Ville",5503,"Gros-de-Vaud",90]
["L'Abbaye",5871,"Jura-Nord vaudois",91]
["L'Abergement",5741,"Jura-Nord vaudois",92]
["Agiez",5742,"Jura-Nord vaudois",93]
["Arnex-sur-Orbe",5743,"Jura-Nord vaudois",94]
["Ballaigues",5744,"Jura-Nord vaudois",95]
["Baulmes",5745,"Jura-Nord vaudois",96]
["Bavois",5746,"Jura-Nord vaudois",97]
["Belmont-sur-Yverdon",5902,"Jura-Nord vaudois",98]
["Bioley-Magnoux",5903,"Jura-Nord vaudois",99]
["Bofflens",5747,"Jura-Nord vaudois",100]
["Bonvillars",5551,"Jura-Nord vaudois",101]
["Bretonnières",5748,"Jura-Nord vaudois",102]
["Bullet",5552,"Jura-Nord vaudois",103]
["Chamblon",5904,"Jura-Nord vaudois",104]
["Champagne",5553,"Jura-Nord vaudois",105]
["Champvent",5905,"Jura-Nord vaudois",106]
["Chavannes-le-Chêne",5907,"Jura-Nord vaudois",107]
["Chavornay",5749,"Jura-Nord vaudois",108]
["Chêne-Pâquier",5908,"Jura-Nord vaudois",109]
["Le Chenit",5872,"Jura-Nord vaudois",110]
["Cheseaux-Noréaz",5909,"Jura-Nord vaudois",111]
["Les Clées",5750,"Jura-Nord vaudois",112]
["Concise",5554,"Jura-Nord vaudois",113]
["Corcelles-près-Concise",5555,"Jura-Nord vaudois",114]
["Corcelles-sur-Chavornay",5751,"Jura-Nord vaudois",115]
["Cronay",5910,"Jura-Nord vaudois",116]
["Croy",5752,"Jura-Nord vaudois",117]
["Cuarny",5911,"Jura-Nord vaudois",118]
["Démoret",5912,"Jura-Nord vaudois",119]
["Donneloye",5913,"Jura-Nord vaudois",120]
["Ependes",5914,"Jura-Nord vaudois",121]
["Essert-Pittet",5915,"Jura-Nord vaudois",122]
["Fiez",5556,"Jura-Nord vaudois",123]
["Fontaines-sur-Grandson",5557,"Jura-Nord vaudois",124]
["Giez",5559,"Jura-Nord vaudois",125]
["Grandevent",5560,"Jura-Nord vaudois",126]
["Grandson",5561,"Jura-Nord vaudois",127]
["Juriens",5754,"Jura-Nord vaudois",128]
["Le Lieu",5873,"Jura-Nord vaudois",129]
["Lignerolle",5755,"Jura-Nord vaudois",130]
["Mathod",5919,"Jura-Nord vaudois",131]
["Mauborget",5562,"Jura-Nord vaudois",132]
["Molondin",5921,"Jura-Nord vaudois",133]
["Montagny-près-Yverdon",5922,"Jura-Nord vaudois",134]
["Montcherand",5756,"Jura-Nord vaudois",135]
["Mutrux",5563,"Jura-Nord vaudois",136]
["Novalles",5564,"Jura-Nord vaudois",137]
["Onnens",5565,"Jura-Nord vaudois",138]
["Orbe",5757,"Jura-Nord vaudois",139]
["Orges",5924,"Jura-Nord vaudois",140]
["Orzens",5925,"Jura-Nord vaudois",141]
["Pomy",5926,"Jura-Nord vaudois",142]
["Praz",5758,"Jura-Nord vaudois",143]
["Premier",5759,"Jura-Nord vaudois",144]
["Provence",5566,"Jura-Nord vaudois",145]
["Rances",5760,"Jura-Nord vaudois",146]
["Romainmôtier-Envy",5761,"Jura-Nord vaudois",147]
["Rovray",5928,"Jura-Nord vaudois",148]
["Sainte-Croix",5568,"Jura-Nord vaudois",149]
["Sergey",5762,"Jura-Nord vaudois",150]
["Suchy",5929,"Jura-Nord vaudois",151]
["Suscévaz",5930,"Jura-Nord vaudois",152]
["Tévenon",5571,"Jura-Nord vaudois",153]
["Treycovagnes",5931,"Jura-Nord vaudois",154]
["Ursins",5932,"Jura-Nord vaudois",155]
["Valeyres-sous-Montagny",5933,"Jura-Nord vaudois",156]
["Valeyres-sous-Rances",5763,"Jura-Nord vaudois",157]
["Valeyres-sous-Ursins",5934,"Jura-Nord vaudois",158]
["Vallorbe",5764,"Jura-Nord vaudois",159]
["Vaulion",5765,"Jura-Nord vaudois",160]
["Villars-Epeney",5935,"Jura-Nord vaudois",161]
["Vugelles-La Mothe",5937,"Jura-Nord vaudois",162]
["Vuiteboeuf",5766,"Jura-Nord vaudois",163]
["Yverdon-les-Bains",5938,"Jura-Nord vaudois",164]
["Yvonand",5939,"Jura-Nord vaudois",165]
["Cheseaux-sur-Lausanne",5582,"Lausanne",166]
["Epalinges",5584,"Lausanne",167]
["Jouxtens-Mézery",5585,"Lausanne",168]
["Lausanne",5586,"Lausanne",169]
["Le Mont-sur-Lausanne",5587,"Lausanne",170]
["Romanel-sur-Lausanne",5592,"Lausanne",171]
["Belmont-sur-Lausanne",5581,"Lavaux-Oron",172]
["Bourg-en-Lavaux",5613,"Lavaux-Oron",173]
["Chexbres",5601,"Lavaux-Oron",174]
["Essertes",5788,"Lavaux-Oron",175]
["Ferlens",5789,"Lavaux-Oron",176]
["Forel (Lavaux)",5604,"Lavaux-Oron",177]
["Lutry",5606,"Lavaux-Oron",178]
["Maracon",5790,"Lavaux-Oron",179]
["Mézières",5791,"Lavaux-Oron",180]
["Montpreveyres",5792,"Lavaux-Oron",181]
["Oron",5805,"Lavaux-Oron",182]
["Paudex",5588,"Lavaux-Oron",183]
["Puidoux",5607,"Lavaux-Oron",184]
["Pully",5590,"Lavaux-Oron",185]
["Rivaz",5609,"Lavaux-Oron",186]
["St-Saphorin (Lavaux)",5610,"Lavaux-Oron",187]
["Savigny",5611,"Lavaux-Oron",188]
["Servion",5799,"Lavaux-Oron",189]
["Aclens",5621,"Morges",190]
["Allaman",5851,"Morges",191]
["Apples",5421,"Morges",192]
["Aubonne",5422,"Morges",193]
["Ballens",5423,"Morges",194]
["Berolle",5424,"Morges",195]
["Bière",5425,"Morges",196]
["Bougy-Villars",5426,"Morges",197]
["Bremblens",5622,"Morges",198]
["Buchillon",5623,"Morges",199]
["Bussy-Chardonney",5625,"Morges",200]
["La Chaux (Cossonay)",5474,"Morges",201]
["Chavannes-le-Veyron",5475,"Morges",202]
["Chevilly",5476,"Morges",203]
["Chigny",5628,"Morges",204]
["Clarmont",5629,"Morges",205]
["Cossonay",5477,"Morges",206]
["Cottens",5478,"Morges",207]
["Cuarnens",5479,"Morges",208]
["Denens",5631,"Morges",209]
["Denges",5632,"Morges",210]
["Dizy",5481,"Morges",211]
["Echandens",5633,"Morges",212]
["Echichens",5634,"Morges",213]
["Eclépens",5482,"Morges",214]
["Etoy",5636,"Morges",215]
["Féchy",5427,"Morges",216]
["Ferreyres",5483,"Morges",217]
["Gimel",5428,"Morges",218]
["Gollion",5484,"Morges",219]
["Grancy",5485,"Morges",220]
["L'Isle",5486,"Morges",221]
["Lavigny",5637,"Morges",222]
["Lonay",5638,"Morges",223]
["Lully",5639,"Morges",224]
["Lussy-sur-Morges",5640,"Morges",225]
["Mauraz",5488,"Morges",226]
["Moiry",5490,"Morges",227]
["Mollens",5431,"Morges",228]
["Montherod",5432,"Morges",229]
["Mont-la-Ville",5491,"Morges",230]
["Montricher",5492,"Morges",231]
["Morges",5642,"Morges",232]
["Orny",5493,"Morges",233]
["Pampigny",5494,"Morges",234]
["Pompaples",5497,"Morges",235]
["Préverenges",5643,"Morges",236]
["Reverolle",5644,"Morges",237]
["Romanel-sur-Morges",5645,"Morges",238]
["Saint-Livres",5435,"Morges",239]
["Saint-Oyens",5436,"Morges",240]
["Saint-Prex",5646,"Morges",241]
["Sarraz",5498,"Morges",242]
["Saubraz",5437,"Morges",243]
["Senarclens",5499,"Morges",244]
["Sévery",5500,"Morges",245]
["Tolochenaz",5649,"Morges",246]
["Vaux-sur-Morges",5650,"Morges",247]
["Villars-sous-Yens",5652,"Morges",248]
["Vufflens-le-Château",5653,"Morges",249]
["Vullierens",5654,"Morges",250]
["Yens",5655,"Morges",251]
["Arnex-sur-Nyon",5701,"Nyon",252]
["Arzier",5702,"Nyon",253]
["Bassins",5703,"Nyon",254]
["Begnins",5704,"Nyon",255]
["Bogis-Bossey",5705,"Nyon",256]
["Borex",5706,"Nyon",257]
["Bursinel",5852,"Nyon",258]
["Bursins",5853,"Nyon",259]
["Burtigny",5854,"Nyon",260]
["Chavannes-de-Bogis",5707,"Nyon",261]
["Chavannes-des-Bois",5708,"Nyon",262]
["Chéserex",5709,"Nyon",263]
["Coinsins",5710,"Nyon",264]
["Commugny",5711,"Nyon",265]
["Coppet",5712,"Nyon",266]
["Crans-près-Céligny",5713,"Nyon",267]
["Crassier",5714,"Nyon",268]
["Duillier",5715,"Nyon",269]
["Dully",5855,"Nyon",270]
["Essertines-sur-Rolle",5856,"Nyon",271]
["Eysins",5716,"Nyon",272]
["Founex",5717,"Nyon",273]
["Genolier",5718,"Nyon",274]
["Gilly",5857,"Nyon",275]
["Gingins",5719,"Nyon",276]
["Givrins",5720,"Nyon",277]
["Gland",5721,"Nyon",278]
["Grens",5722,"Nyon",279]
["Longirod",5429,"Nyon",280]
["Luins",5858,"Nyon",281]
["Marchissy",5430,"Nyon",282]
["Mies",5723,"Nyon",283]
["Mont-sur-Rolle",5859,"Nyon",284]
["Nyon",5724,"Nyon",285]
["Perroy",5860,"Nyon",286]
["Prangins",5725,"Nyon",287]
["La Rippe",5726,"Nyon",288]
["Rolle",5861,"Nyon",289]
["Saint-Cergue",5727,"Nyon",290]
["Saint-George",5434,"Nyon",291]
["Signy-Avenex",5728,"Nyon",292]
["Tannay",5729,"Nyon",293]
["Tartegnin",5862,"Nyon",294]
["Trélex",5730,"Nyon",295]
["Le Vaud",5731,"Nyon",296]
["Vich",5732,"Nyon",297]
["Vinzel",5863,"Nyon",298]
["Bussigny",5624,"Ouest lausannois",299]
["Chavannes-près-Renens",5627,"Ouest lausannois",300]
["Crissier",5583,"Ouest lausannois",301]
["Ecublens",5635,"Ouest lausannois",302]
["Prilly",5589,"Ouest lausannois",303]
["Renens",5591,"Ouest lausannois",304]
["Saint-Sulpice",5648,"Ouest lausannois",305]
["Villars-Sainte-Croix",5651,"Ouest lausannois",306]
["Blonay",5881,"Riviera-Pays-d'Enhaut",307]
["Chardonne",5882,"Riviera-Pays-d'Enhaut",308]
["Château-d'Oex",5841,"Riviera-Pays-d'Enhaut",309]
["Corseaux",5883,"Riviera-Pays-d'Enhaut",310]
["Corsier-sur-Vevey",5884,"Riviera-Pays-d'Enhaut",311]
["Jongny",5885,"Riviera-Pays-d'Enhaut",312]
["Montreux",5886,"Riviera-Pays-d'Enhaut",313]
["Rossinière",5842,"Riviera-Pays-d'Enhaut",314]
["Rougemont",5843,"Riviera-Pays-d'Enhaut",315]
["Saint-Légier-La Chiésaz",5888,"Riviera-Pays-d'Enhaut",316]
["La Tour-de-Peilz",5889,"Riviera-Pays-d'Enhaut",317]
["Vevey",5890,"Riviera-Pays-d'Enhaut",318]
["Veytaux",5891,"Riviera-Pays-d'Enhaut",319]
[null,null,null,320]
[null,null,null,321]
[null,null,null,322]
[null,null,null,323]
[null,null,null,324]
[null,null,null,325]
[null,null,null,326]
[null,null,null,327]
[null,null,null,328]
[null,null,null,329]
[null,null,null,330]
[null,null,null,331]
[null,null,null,332]
[null,null,null,333]
[null,null,null,334]
[null,null,null,335]
[null,null,null,336]
[null,null,null,337]
[null,null,null,338]
[null,null,null,339]
[null,null,null,340]
[null,null,null,341]
[null,null,null,342]
[null,null,null,343]
[null,null,null,344]
[null,null,null,345]
[null,null,null,346]
[null,null,null,347]
[null,null,null,348]
[null,null,null,349]
[null,null,null,350]
[null,null,null,351]
[null,null,null,352]
[null,null,null,353]
[null,null,null,354]
[null,null,null,355]
[null,null,null,356]
[null,null,null,357]
[null,null,null,358]
[null,null,null,359]
[null,null,null,360]
[null,null,null,361]
[null,null,null,362]
[null,null,null,363]
[null,null,null,364]
[null,null,null,365]
[null,null,null,366]
[null,null,null,367]
[null,null,null,368]
[null,null,null,369]
[null,null,null,370]
[null,null,null,371]
[null,null,null,372]
[null,null,null,373]
[null,null,null,374]
[null,null,null,375]
[null,null,null,376]
[null,null,null,377]
[null,null,null,378]
[null,null,null,379]
[null,null,null,380]
[null,null,null,381]
[null,null,null,382]
[null,null,null,383]
[null,null,null,384]
[null,null,null,385]
[null,null,null,386]
[null,null,null,387]
[null,null,null,388]
[null,null,null,389]
[null,null,null,390]
[null,null,null,391]
[null,null,null,392]
[null,null,null,393]
[null,null,null,394]
[null,null,null,395]
[null,null,null,396]
[null,null,null,397]
[null,null,null,398]
[null,null,null,399]
[null,null,null,400]